UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h8W144b1PKQlMytjOTtlE5NlAfFjoOG4CxSJW6OhdgM='
WHERE
key_id = '044702a6342dc97d8e3eb99b812db6f9bd54d2a1adfa348332c3caff48bed69a'
AND (
token = 'h8W144b1PKQlMytjOTtlE5NlAfFjoOG4CxSJW6OhdgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)