UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXKjexxSbRpym0xtJY0EHa1dWhOaNGKrgXS/U2ZZXNM='
WHERE
key_id = '5ab823e3e9e7fbe014962061505a5c4955fc92c933ed143cb2bd74abbed833bb'
AND (
token = 'sXKjexxSbRpym0xtJY0EHa1dWhOaNGKrgXS/U2ZZXNM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)