UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jmImZyKRwnYV7YOc2FUUdcn/WtBeASXE00TFsT9SII='
WHERE
key_id = 'dc72a95439cd70f02398195da78362d7e691b85a36bebb3a2d4d24b850d0f4f6'
AND (
token = '9jmImZyKRwnYV7YOc2FUUdcn/WtBeASXE00TFsT9SII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)