UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u5RcAm1gNPtTiRrsX9bz2UolVgFWYaEvvUuwcVQhQGU='
WHERE
key_id = '3deabc05c78c3efc0e09f38a5fed53ee97f73233331481dd40a3e717caf8b70a'
AND (
token = 'u5RcAm1gNPtTiRrsX9bz2UolVgFWYaEvvUuwcVQhQGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)