UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2WA9cr2AR1ut+Uyb4ViH32GF0J813hiLDrtb8x4ALlk='
WHERE
key_id = '512731769c91c27d23007c912a0a8904e9aab2e9a4d151b78f457d5d6d31bd0e'
AND (
token = '2WA9cr2AR1ut+Uyb4ViH32GF0J813hiLDrtb8x4ALlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)