UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y9VvLPHQ/BORp6EKq/I65kpyfBpXlbEioUzpuCmWfg0='
WHERE
key_id = 'bd94f8c170a7a20910af7b58d412b9eafdf3a839a4feb45b20cbbdeca1b30e12'
AND (
token = 'Y9VvLPHQ/BORp6EKq/I65kpyfBpXlbEioUzpuCmWfg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)