UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8bEAd5xsRnfMPEZdB8MslfEyohFP/M6ZOISq59IzHY='
WHERE
key_id = '8aba0b137b5ea839c72eaf2c289e337666dd4f3c3892502007a72a2238e28b39'
AND (
token = 'p8bEAd5xsRnfMPEZdB8MslfEyohFP/M6ZOISq59IzHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)