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