UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QGDPK9iJPfTUhAZ94Sa8NmhZQtPFUyUGpc+x9ALldpY='
WHERE
key_id = 'd1b1556988eb26a8414e0ca3b2f67885e94a146cc29a961b23a525c48446500f'
AND (
token = 'QGDPK9iJPfTUhAZ94Sa8NmhZQtPFUyUGpc+x9ALldpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)