UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'scKrypGjgLivlnHeW7rTPUUj+Zpq5h0uLMYVkver3CU='
WHERE
key_id = '49659d59056b8d992b45d6c3f44b2061708abb48cafeb1c93189fcc3e5c71d4c'
AND (
token = 'scKrypGjgLivlnHeW7rTPUUj+Zpq5h0uLMYVkver3CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)