UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l/Ps8VW8l3/J1GRdYf5FQINP/fUo2OmFBJs06Lr9Fd4='
WHERE
key_id = 'c080062b6c2aa648893b972dce4f7cf03752f73383c2ed48a178643ae35a0e7a'
AND (
token = 'l/Ps8VW8l3/J1GRdYf5FQINP/fUo2OmFBJs06Lr9Fd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)