UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZvP8ioUTr1wM7jgMNE8zV9QmcULs+LGzDoag0UOIXy0='
WHERE
key_id = 'ca9b7efced1c52cd9016ac0c01d33143d79aaeb988dbfb1a0b48f5aba54abd2f'
AND (
token = 'ZvP8ioUTr1wM7jgMNE8zV9QmcULs+LGzDoag0UOIXy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)