UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iz1MO97/PdzdMAGRXfXL5PYfBFsehyIitD5rv4dTdBY='
WHERE
key_id = '9a67b64c6341c911bc658394b723c7072466ddd7cf73f485c1159f2411943ea1'
AND (
token = 'iz1MO97/PdzdMAGRXfXL5PYfBFsehyIitD5rv4dTdBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)