UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ycpyX6INiG0DCYc49fwjj9FuHau71UvkykzR9Xw0IM='
WHERE
key_id = '4f821f0e5c76683129f89636f0fc0afc27e0cd556a991bbdb160f66f33856b42'
AND (
token = '6ycpyX6INiG0DCYc49fwjj9FuHau71UvkykzR9Xw0IM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)