UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIhIHrMXxBcKKVY+Ud0TmNIMB+1veviw9xRvlJgYYWQ='
WHERE
key_id = 'c8b0217be220d4929f08dee478c4c540c89bb9af17230ee3fe65178a7b68910a'
AND (
token = 'zIhIHrMXxBcKKVY+Ud0TmNIMB+1veviw9xRvlJgYYWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)