UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QSJ2HI6pZRT67jP1ladVgOJy5zjc604LJFSKKwV/ZFs='
WHERE
key_id = 'dcd1be79f89137b8887597ec4d2e7660363b4f6c262a5fa37573d8654e5734d5'
AND (
token = 'QSJ2HI6pZRT67jP1ladVgOJy5zjc604LJFSKKwV/ZFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)