UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zyLUJc7fwLJ/tp7o8L92rwUZ9RGOddSuZkL2z9PTTXI='
WHERE
key_id = 'dc020d55b2393f566b2f03405fcc8ae96a76c74a3d06212199142398c667ae57'
AND (
token = 'zyLUJc7fwLJ/tp7o8L92rwUZ9RGOddSuZkL2z9PTTXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)