UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mFgXKwV6tVZshijBqfBimG1/r9N2lF8KVr0L0pXzgaU='
WHERE
key_id = 'e697622b12a470d7cfe283d30f29dcc181c2ab6d2067e3551fbf9608589a294f'
AND (
token = 'mFgXKwV6tVZshijBqfBimG1/r9N2lF8KVr0L0pXzgaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)