UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1y/xtPfcY8lgZ/IqEBL4Ovs6RoamSGOt96p6Yu48/Dw='
WHERE
key_id = '18874f23cc599ea43a4d314cb82b1d1a4b8ad46e72d71a7b337c720d7f1c7f80'
AND (
token = '1y/xtPfcY8lgZ/IqEBL4Ovs6RoamSGOt96p6Yu48/Dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)