UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CfoXQ33aUIOXS1+lUMc9AI/rMRxtIIsU/xl3dUMQpo0='
WHERE
key_id = '86da9370200d22094a3dabc3428b9a0942cff71cfe83a8b0decac9c81adb2e3f'
AND (
token = 'CfoXQ33aUIOXS1+lUMc9AI/rMRxtIIsU/xl3dUMQpo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)