UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ctWVVHcmdtWn488BiUlKx5aIjKMuhKz+Kq5KUlC29Xs='
WHERE
key_id = 'f6504edc8c5a23a38f4b7e8c40b62290ff5e53ad784e92a909c9db7698a04b02'
AND (
token = 'ctWVVHcmdtWn488BiUlKx5aIjKMuhKz+Kq5KUlC29Xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)