UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mdcWeeUrXheAlGsDFWdwrUyXxUEs/kdrqSeIjk/CvXk='
WHERE
key_id = 'ca564065d9037d0275580f98da4db7003f88cdef73eb8a15a4775ca82a24cf64'
AND (
token = 'mdcWeeUrXheAlGsDFWdwrUyXxUEs/kdrqSeIjk/CvXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)