UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YlPKnvD7WrVuED4sSMdjr9AsTM9ZyDobsN/7EcGCXDk='
WHERE
key_id = '97a9639e571863fd1725322075db248b354824161cfc2c87742451841ed5b09b'
AND (
token = 'YlPKnvD7WrVuED4sSMdjr9AsTM9ZyDobsN/7EcGCXDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)