UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xuzuC2v3IZhkDSWYJBnf0qptb7wIog8GRPvZipCO32Y='
WHERE
key_id = '24012b322a5592bcedc01f27ae728ba25a8ba87021727ab9c6d2d24dc5f4d2d7'
AND (
token = 'xuzuC2v3IZhkDSWYJBnf0qptb7wIog8GRPvZipCO32Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)