UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ug5GnEP9y4or7OFSCHWRhX/yCN4sMgx01Snm7Ukm/DM='
WHERE
key_id = 'b4862a90428d45d9958805bfc901e21166971e57a19a90fe2e7e7b868293c8b1'
AND (
token = 'ug5GnEP9y4or7OFSCHWRhX/yCN4sMgx01Snm7Ukm/DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)