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