UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T9yUuSffIrXTX0wcp8K7eSm8p/0N1eFMtXy0+Jmuz/k='
WHERE
key_id = '5278da4c6288b4bcb12e57c2681de68b4c40a0b4fff2ef30e2654d8027c73576'
AND (
token = 'T9yUuSffIrXTX0wcp8K7eSm8p/0N1eFMtXy0+Jmuz/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)