UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+X9uxkvj8c0wewqOxNSD2MYmUQ5sjWuWJxGUWjKQ0Sc='
WHERE
key_id = 'c63ecef704057a66d5d783ab72691fb34440261a3808d45cc7c833a169005be3'
AND (
token = '+X9uxkvj8c0wewqOxNSD2MYmUQ5sjWuWJxGUWjKQ0Sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)