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