UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a5IBcZWuzfQRJWiD1U2IizELUwn+KYkZCt0723Yt6OE='
WHERE
key_id = '3c2d9ea654b648c1873003164aef6bb6f97ad30f05b08993383e648cac99f11e'
AND (
token = 'a5IBcZWuzfQRJWiD1U2IizELUwn+KYkZCt0723Yt6OE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)