UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PHM6MacmqHEaKRI8u+r9+Wipb/hs5aK1Es5tGuiZt8M='
WHERE
key_id = '3c7df8f837cb4f43b8327b0f2942de9e6464f1a9be76347918c21a0214d90264'
AND (
token = 'PHM6MacmqHEaKRI8u+r9+Wipb/hs5aK1Es5tGuiZt8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)